DSP® Application Development

Set a Column's Format

Some control types allow a user to set the column’s format.

Control

Formats

Text Box
  • Email
  • Password
  • Text

Text Area

SQL

Numeric
  • Currency
  • Numeric
  • Numeric Positive
  • Percent
  • Zero Padded Integer

DateTime
  • Date
  • Date and Time
  • Formatted Date
  • Formatted Time
  • Time
  • Time (24 hour)

Check Box
  • SAP BDC

NOTE: A check box using this format allows the values ˜X" for checked and "!" for unchecked. The "!" is a special character used in an SAP BDC that tells the program there is no data in the field (i.e., the field should be ignored). This is useful when doing an update to existing data in SAP and the data must not change unless it has been modified.

  • SAP Checkbox - Deprecated

NOTE: A check box using this format allows the values ˜X" for checked and ˜ ˜ for unchecked.

  • Y or N

NOTE: A check box using this format allows the values ˜Y" for checked and ˜N" for unchecked.

NOTE: If one of these formats is chosen for the check box, the data type of the table column in SQL must be set to a character of length 1. The user receives a hard error while entering data on the page if one of these check box formats is selected and the data type of the field is bit or another non-character format.

NOTE: If the data type of the table column in SQL is set to bit, the DSP® assumes the field is a check box and appropriately populates the data with a 1 or 0.

To apply formatting to a column, select an option from the Format list box on the Page Columns page's Vertical View. For a check box, select an option from the Checkbox Format ID list box. Numeric fields allow for additional formatting options.

To apply additional formats to a numeric column:

  1. Access the Page Columns Vertical View for a Numeric column.

  2. Click Edit.

    View the field descriptions for the Page Columns page

  3. Select an option from theFormat list box.

    NOTE: Depending on the Format selected and the purpose of the field, set these additional options.

  4. Enter a value in the Numeric Scale text box.

    NOTE: The Numeric Scale field determines the number of decimal places to display after the decimal separator.

  5. Click Display Thousands Separator check box.

    NOTE: The Display Thousands Separator will force a number to use the current user’s locale to display a number such as 4213.22 as 4,213.22 given that English – United States is selected in the Currency Locale ID list box.

  6. Click Total check box.

    NOTE: A totals column recalculates when records are added, deleted, or modified.

  7. Click Save.